<?php


namespace App\Http\Model\Common;


use Illuminate\Support\Facades\DB;

class PfsModel
{

    /**
     * 查询需要返回的列表
     *
     * @param $where
     * @param $id
     *
     * @return array
     */
    public static function search($where, $id)
    {
        return DB::select("SELECT id,`pfs_agencyid`,`desc` FROM `pfs_dw_ini` WHERE id IN ({$id}) AND `is_del`=0 AND (`desc` LIKE :desc OR `pfs_agencyid` LIKE :pfs_agencyid) group by `pfs_agencyid` LIMIT 300", [
            'desc'         => "%{$where}%",
            'pfs_agencyid' => "%{$where}%",
        ]);
    }

}





/**
 * PfsModel.php
 *
 * 说明:
 *
 * 修改历史
 * ----------------------------------------
 * 2021/6/15 10:16:00   操作:创建
 **/
